package com.ctshk.rpc.goods.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ctshk.rpc.goods.entity.ShoppingCommoditySpecificationsName;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 商城商品规格名称 Mapper 接口
 * </p>
 *
 * @author 黄利斌
 * @since 2021-06-02
 */
public interface ShoppingCommoditySpecificationsNameMapper extends BaseMapper<ShoppingCommoditySpecificationsName> {

    /**
     * 根据id查询商品规格信息
     * @param specificationsNameId
     * @return
     */
    @Select({
            "SELECT id,specifications_name,specifications_number,create_id,modified_id,is_deleted,gmt_create,gmt_modified " +
                    "FROM `ctshk-goods`.t_shopping_commodity_specifications_name " +
                    "WHERE id=#{id}"
    })
    ShoppingCommoditySpecificationsName selectInfoById(@Param("id") Long specificationsNameId);
}
